/*
 Navicat Premium Data Transfer

 Source Server         : docker_db
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : 127.0.0.1
 Source Database       : easyadmin

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : utf-8

 Date: 09/16/2020 17:09:34 PM
*/

SET NAMES utf8mb4;
#SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ea_mall_cate`
-- ----------------------------
DROP TABLE IF EXISTS `ea_mall_cate`;
CREATE TABLE `ea_mall_cate` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL COMMENT '分类名',
  `image` varchar(500) DEFAULT NULL COMMENT '分类图片',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='商品分类';

-- ----------------------------
--  Records of `ea_mall_cate`
-- ----------------------------
BEGIN;
INSERT INTO `ea_mall_cate` VALUES ('9', '手机', 'http://admin.host/upload/20200514/98fc09b0c4ad4d793a6f04bef79a0edc.jpg', '0', '1', '', '1589440437', '1589440437', null);
COMMIT;

-- ----------------------------
--  Table structure for `ea_mall_goods`
-- ----------------------------
DROP TABLE IF EXISTS `ea_mall_goods`;
CREATE TABLE `ea_mall_goods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cate_id` int(11) DEFAULT NULL COMMENT '分类ID',
  `title` varchar(20) NOT NULL COMMENT '商品名称',
  `logo` varchar(500) DEFAULT NULL COMMENT '商品logo',
  `images` text COMMENT '商品图片 以 | 做分割符号',
  `describe` text COMMENT '商品描述',
  `market_price` decimal(10,2) DEFAULT '0.00' COMMENT '市场价',
  `discount_price` decimal(10,2) DEFAULT '0.00' COMMENT '折扣价',
  `sales` int(11) DEFAULT '0' COMMENT '销量',
  `virtual_sales` int(11) DEFAULT '0' COMMENT '虚拟销量',
  `stock` int(11) DEFAULT '0' COMMENT '库存',
  `total_stock` int(11) DEFAULT '0' COMMENT '总库存',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`),
  KEY `cate_id` (`cate_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='商品列表';

-- ----------------------------
--  Records of `ea_mall_goods`
-- ----------------------------
BEGIN;
INSERT INTO `ea_mall_goods` VALUES ('8', '10', '落地-风扇', 'http://admin.host/upload/20200514/a0f7fe9637abd219f7e93ceb2820df9b.jpg', 'http://admin.host/upload/20200514/95496713918290f6315ea3f87efa6bf2.jpg|http://admin.host/upload/20200514/ae29fa9cba4fc02defb7daed41cb2b13.jpg|http://admin.host/upload/20200514/f0a104d88ec7dc6fb42d2f87cbc71b76.jpg|http://admin.host/upload/20200514/3b88be4b1934690e5c1bd6b54b9ab5c8.jpg', '<p>76654757</p>\n\n<p><img alt=\"\" src=\"http://admin.host/upload/20200515/198070421110fa01f2c2ac2f52481647.jpg\" style=\"height:689px; width:790px\" /></p>\n\n<p><img alt=\"\" src=\"http://admin.host/upload/20200515/a07a742c15a78781e79f8a3317006c1d.jpg\" style=\"height:877px; width:790px\" /></p>\n', '599.00', '368.00', '0', '594', '0', '0', '675', '1', '', '1589454309', '1589567016', null), ('9', '9', '电脑', 'http://admin.host/upload/20200514/bbf858d469dec2e12a89460110068d3d.jpg', 'http://admin.host/upload/20200514/f0a104d88ec7dc6fb42d2f87cbc71b76.jpg', '<p>477</p>\n', '0.00', '0.00', '0', '0', '115', '320', '0', '1', '', '1589465215', '1589476345', null);
COMMIT;

-- ----------------------------
--  Table structure for `ea_system_admin`
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_admin`;
CREATE TABLE `ea_system_admin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `auth_ids` varchar(255) DEFAULT NULL COMMENT '角色权限ID',
  `head_img` varchar(255) DEFAULT NULL COMMENT '头像',
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户登录名',
  `password` char(40) NOT NULL DEFAULT '' COMMENT '用户登录密码',
  `phone` varchar(16) DEFAULT NULL COMMENT '联系手机号',
  `remark` varchar(255) DEFAULT '' COMMENT '备注说明',
  `login_num` bigint(20) unsigned DEFAULT '0' COMMENT '登录次数',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用,)',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE,
  KEY `phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统用户表';

-- ----------------------------
--  Records of `ea_system_admin`
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_admin` VALUES ('1', null, '/static/admin/images/head.jpg', 'admin', 'a33b679d5581a8692988ec9f92ad2d6a2259eaa7', null, '', '1', '0', '1', '1600245076', '1600245090', null);
COMMIT;

-- ----------------------------
--  Table structure for `ea_system_auth`
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_auth`;
CREATE TABLE `ea_system_auth` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL COMMENT '权限名称',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统权限表';

-- ----------------------------
--  Records of `ea_system_auth`
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_auth` VALUES ('1', '管理员', '1', '1', '测试管理员', '1588921753', '1589614331', null), ('6', '游客权限', '0', '1', '', '1588227513', '1589591751', '1589591751');
COMMIT;

-- ----------------------------
--  Table structure for `ea_system_auth_node`
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_auth_node`;
CREATE TABLE `ea_system_auth_node` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `auth_id` bigint(20) unsigned DEFAULT NULL COMMENT '角色ID',
  `node_id` bigint(20) DEFAULT NULL COMMENT '节点ID',
  PRIMARY KEY (`id`),
  KEY `index_system_auth_auth` (`auth_id`) USING BTREE,
  KEY `index_system_auth_node` (`node_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色与节点关系表';

-- ----------------------------
--  Records of `ea_system_auth_node`
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_auth_node` VALUES ('1', '6', '1'), ('2', '6', '2'), ('3', '6', '9'), ('4', '6', '12'), ('5', '6', '18'), ('6', '6', '19'), ('7', '6', '21'), ('8', '6', '22'), ('9', '6', '29'), ('10', '6', '30'), ('11', '6', '38'), ('12', '6', '39'), ('13', '6', '45'), ('14', '6', '46'), ('15', '6', '52'), ('16', '6', '53');
COMMIT;

-- ----------------------------
--  Table structure for `ea_system_config`
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_config`;
CREATE TABLE `ea_system_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '变量名',
  `group` varchar(30) NOT NULL DEFAULT '' COMMENT '分组',
  `value` text COMMENT '变量值',
  `remark` varchar(100) DEFAULT '' COMMENT '备注信息',
  `sort` int(10) DEFAULT '0',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `group` (`group`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统配置表';

-- ----------------------------
--  Records of `ea_system_config`
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_config` VALUES ('41', 'alisms_access_key_id', 'sms', '填你的', '阿里大于公钥', '0', null, null), ('42', 'alisms_access_key_secret', 'sms', '填你的', '阿里大鱼私钥', '0', null, null), ('55', 'upload_type', 'upload', 'local', '当前上传方式 （local,alioss,qnoss,txoss）', '0', null, null), ('56', 'upload_allow_ext', 'upload', 'doc,gif,ico,icon,jpg,mp3,mp4,p12,pem,png,rar,jpeg', '允许上传的文件类型', '0', null, null), ('57', 'upload_allow_size', 'upload', '1024000', '允许上传的大小', '0', null, null), ('58', 'upload_allow_mime', 'upload', 'image/gif,image/jpeg,video/x-msvideo,text/plain,image/png', '允许上传的文件mime', '0', null, null), ('59', 'upload_allow_type', 'upload', 'local,alioss,qnoss,txcos', '可用的上传文件方式', '0', null, null), ('60', 'alioss_access_key_id', 'upload', '填你的', '阿里云oss公钥', '0', null, null), ('61', 'alioss_access_key_secret', 'upload', '填你的', '阿里云oss私钥', '0', null, null), ('62', 'alioss_endpoint', 'upload', '填你的', '阿里云oss数据中心', '0', null, null), ('63', 'alioss_bucket', 'upload', '填你的', '阿里云oss空间名称', '0', null, null), ('64', 'alioss_domain', 'upload', '填你的', '阿里云oss访问域名', '0', null, null), ('65', 'logo_title', 'site', 'EasyAdmin', 'LOGO标题', '0', null, null), ('66', 'logo_image', 'site', '/favicon.ico', 'logo图片', '0', null, null), ('68', 'site_name', 'site', 'EasyAdmin后台系统', '站点名称', '0', null, null), ('69', 'site_ico', 'site', 'https://lxn-99php.oss-cn-shenzhen.aliyuncs.com/upload/20191111/7d32671f4c1d1b01b0b28f45205763f9.ico', '浏览器图标', '0', null, null), ('70', 'site_copyright', 'site', '©版权所有 2014-2018 叁贰柒工作室66', '版权信息', '0', null, null), ('71', 'site_beian', 'site', '粤ICP备16006642号-2', '备案信息', '0', null, null), ('72', 'site_version', 'site', '2.0.0', '版本信息', '0', null, null), ('75', 'sms_type', 'sms', 'alisms', '短信类型', '0', null, null), ('76', 'miniapp_appid', 'wechat', '填你的', '小程序公钥', '0', null, null), ('77', 'miniapp_appsecret', 'wechat', '填你的', '小程序私钥', '0', null, null), ('78', 'web_appid', 'wechat', '填你的', '公众号公钥', '0', null, null), ('79', 'web_appsecret', 'wechat', '填你的', '公众号私钥', '0', null, null), ('80', 'txcos_secret_id', 'upload', '填你的', '腾讯云cos密钥', '0', null, null), ('81', 'txcos_secret_key', 'upload', '填你的', '腾讯云cos私钥', '0', null, null), ('82', 'txcos_region', 'upload', '填你的', '存储桶地域', '0', null, null), ('83', 'tecos_bucket', 'upload', '填你的', '存储桶名称', '0', null, null), ('84', 'qnoss_access_key', 'upload', '填你的', '访问密钥', '0', null, null), ('85', 'qnoss_secret_key', 'upload', '填你的', '安全密钥', '0', null, null), ('86', 'qnoss_bucket', 'upload', '填你的', '存储空间', '0', null, null), ('87', 'qnoss_domain', 'upload', '填你的', '访问域名', '0', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `ea_system_log_202009`
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_log_202009`;
CREATE TABLE `ea_system_log_202009` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int(10) unsigned DEFAULT '0' COMMENT '管理员ID',
  `url` varchar(1500) NOT NULL DEFAULT '' COMMENT '操作页面',
  `method` varchar(50) NOT NULL COMMENT '请求方法',
  `title` varchar(100) DEFAULT '' COMMENT '日志标题',
  `content` text NOT NULL COMMENT '内容',
  `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP',
  `useragent` varchar(255) DEFAULT '' COMMENT 'User-Agent',
  `create_time` int(10) DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=634 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='后台操作日志表 - 202009';

-- ----------------------------
--  Records of `ea_system_log_202009`
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_log_202009` VALUES ('630', null, '/admin/login/index.html', 'post', '', '{\"username\":\"admin\",\"password\":\"a33b679d5581a8692988ec9f92ad2d6a2259eaa7\",\"captcha\":\"w5G4\",\"keep_login\":\"0\"}', '172.19.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', '1600245089'), ('631', '1', '/admin/system.admin/modify', 'post', '', '{\"id\":\"1\",\"field\":\"status\",\"value\":\"0\"}', '172.19.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', '1600245211'), ('632', '1', '/admin/system.admin/modify', 'post', '', '{\"id\":\"1\",\"field\":\"status\",\"value\":\"0\"}', '172.19.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', '1600245213'), ('633', '1', '/admin/ajax/upload', 'post', '', '[]', '172.19.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', '1600245941');
COMMIT;

-- ----------------------------
--  Table structure for `ea_system_menu`
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_menu`;
CREATE TABLE `ea_system_menu` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父id',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
  `icon` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单图标',
  `href` varchar(100) NOT NULL DEFAULT '' COMMENT '链接',
  `params` varchar(500) DEFAULT '' COMMENT '链接参数',
  `target` varchar(20) NOT NULL DEFAULT '_self' COMMENT '链接打开方式',
  `sort` int(11) DEFAULT '0' COMMENT '菜单排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
  `remark` varchar(255) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `href` (`href`)
) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统菜单表';

-- ----------------------------
--  Records of `ea_system_menu`
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_menu` VALUES ('227', '99999999', '后台首页', 'fa fa-home', 'index/welcome', '', '_self', '0', '1', null, null, '1573120497', null), ('228', '0', '系统管理', 'fa fa-cog', '', '', '_self', '0', '1', '', null, '1588999529', null), ('234', '228', '菜单管理', 'fa fa-tree', 'system.menu/index', '', '_self', '10', '1', '', null, '1588228555', null), ('244', '228', '管理员管理', 'fa fa-user', 'system.admin/index', '', '_self', '12', '1', '', '1573185011', '1588228573', null), ('245', '228', '角色管理', 'fa fa-bitbucket-square', 'system.auth/index', '', '_self', '11', '1', '', '1573435877', '1588228634', null), ('246', '228', '节点管理', 'fa fa-list', 'system.node/index', '', '_self', '9', '1', '', '1573435919', '1588228648', null), ('247', '228', '配置管理', 'fa fa-asterisk', 'system.config/index', '', '_self', '8', '1', '', '1573457448', '1588228566', null), ('248', '228', '上传管理', 'fa fa-arrow-up', 'system.uploadfile/index', '', '_self', '0', '1', '', '1573542953', '1588228043', null), ('249', '0', '商城管理', 'fa fa-list', '', '', '_self', '0', '1', '', '1589439884', '1589439884', null), ('250', '249', '商品分类', 'fa fa-calendar-check-o', 'mall.cate/index', '', '_self', '0', '1', '', '1589439910', '1589439966', null), ('251', '249', '商品管理', 'fa fa-list', 'mall.goods/index', '', '_self', '0', '1', '', '1589439931', '1589439942', null), ('252', '228', '快捷入口', 'fa fa-list', 'system.quick/index', '', '_self', '0', '1', '', '1589623683', '1589623683', null), ('253', '228', '日志管理', 'fa fa-connectdevelop', 'system.log/index', '', '_self', '0', '1', '', '1589623684', '1589623684', null);
COMMIT;

-- ----------------------------
--  Table structure for `ea_system_node`
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_node`;
CREATE TABLE `ea_system_node` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `node` varchar(100) DEFAULT NULL COMMENT '节点代码',
  `title` varchar(500) DEFAULT NULL COMMENT '节点标题',
  `type` tinyint(1) DEFAULT '3' COMMENT '节点类型（1：控制器，2：节点）',
  `is_auth` tinyint(1) unsigned DEFAULT '1' COMMENT '是否启动RBAC权限控制',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `node` (`node`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统节点表';

-- ----------------------------
--  Records of `ea_system_node`
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_node` VALUES ('1', 'system.admin', '管理员管理', '1', '1', '1589580432', '1589580432'), ('2', 'system.admin/index', '列表', '2', '1', '1589580432', '1589580432'), ('3', 'system.admin/add', '添加', '2', '1', '1589580432', '1589580432'), ('4', 'system.admin/edit', '编辑', '2', '1', '1589580432', '1589580432'), ('5', 'system.admin/password', '编辑', '2', '1', '1589580432', '1589580432'), ('6', 'system.admin/delete', '删除', '2', '1', '1589580432', '1589580432'), ('7', 'system.admin/modify', '属性修改', '2', '1', '1589580432', '1589580432'), ('8', 'system.admin/export', '导出', '2', '1', '1589580432', '1589580432'), ('9', 'system.auth', '角色权限管理', '1', '1', '1589580432', '1589580432'), ('10', 'system.auth/authorize', '授权', '2', '1', '1589580432', '1589580432'), ('11', 'system.auth/saveAuthorize', '授权保存', '2', '1', '1589580432', '1589580432'), ('12', 'system.auth/index', '列表', '2', '1', '1589580432', '1589580432'), ('13', 'system.auth/add', '添加', '2', '1', '1589580432', '1589580432'), ('14', 'system.auth/edit', '编辑', '2', '1', '1589580432', '1589580432'), ('15', 'system.auth/delete', '删除', '2', '1', '1589580432', '1589580432'), ('16', 'system.auth/export', '导出', '2', '1', '1589580432', '1589580432'), ('17', 'system.auth/modify', '属性修改', '2', '1', '1589580432', '1589580432'), ('18', 'system.config', '系统配置管理', '1', '1', '1589580432', '1589580432'), ('19', 'system.config/index', '列表', '2', '1', '1589580432', '1589580432'), ('20', 'system.config/save', '保存', '2', '1', '1589580432', '1589580432'), ('21', 'system.menu', '菜单管理', '1', '1', '1589580432', '1589580432'), ('22', 'system.menu/index', '列表', '2', '1', '1589580432', '1589580432'), ('23', 'system.menu/add', '添加', '2', '1', '1589580432', '1589580432'), ('24', 'system.menu/edit', '编辑', '2', '1', '1589580432', '1589580432'), ('25', 'system.menu/delete', '删除', '2', '1', '1589580432', '1589580432'), ('26', 'system.menu/modify', '属性修改', '2', '1', '1589580432', '1589580432'), ('27', 'system.menu/getMenuTips', '添加菜单提示', '2', '1', '1589580432', '1589580432'), ('28', 'system.menu/export', '导出', '2', '1', '1589580432', '1589580432'), ('29', 'system.node', '系统节点管理', '1', '1', '1589580432', '1589580432'), ('30', 'system.node/index', '列表', '2', '1', '1589580432', '1589580432'), ('31', 'system.node/refreshNode', '系统节点更新', '2', '1', '1589580432', '1589580432'), ('32', 'system.node/clearNode', '清除失效节点', '2', '1', '1589580432', '1589580432'), ('33', 'system.node/add', '添加', '2', '1', '1589580432', '1589580432'), ('34', 'system.node/edit', '编辑', '2', '1', '1589580432', '1589580432'), ('35', 'system.node/delete', '删除', '2', '1', '1589580432', '1589580432'), ('36', 'system.node/export', '导出', '2', '1', '1589580432', '1589580432'), ('37', 'system.node/modify', '属性修改', '2', '1', '1589580432', '1589580432'), ('38', 'system.uploadfile', '上传文件管理', '1', '1', '1589580432', '1589580432'), ('39', 'system.uploadfile/index', '列表', '2', '1', '1589580432', '1589580432'), ('40', 'system.uploadfile/add', '添加', '2', '1', '1589580432', '1589580432'), ('41', 'system.uploadfile/edit', '编辑', '2', '1', '1589580432', '1589580432'), ('42', 'system.uploadfile/delete', '删除', '2', '1', '1589580432', '1589580432'), ('43', 'system.uploadfile/export', '导出', '2', '1', '1589580432', '1589580432'), ('44', 'system.uploadfile/modify', '属性修改', '2', '1', '1589580432', '1589580432'), ('45', 'mall.cate', '商品分类管理', '1', '1', '1589580432', '1589580432'), ('46', 'mall.cate/index', '列表', '2', '1', '1589580432', '1589580432'), ('47', 'mall.cate/add', '添加', '2', '1', '1589580432', '1589580432'), ('48', 'mall.cate/edit', '编辑', '2', '1', '1589580432', '1589580432'), ('49', 'mall.cate/delete', '删除', '2', '1', '1589580432', '1589580432'), ('50', 'mall.cate/export', '导出', '2', '1', '1589580432', '1589580432'), ('51', 'mall.cate/modify', '属性修改', '2', '1', '1589580432', '1589580432'), ('52', 'mall.goods', '商城商品管理', '1', '1', '1589580432', '1589580432'), ('53', 'mall.goods/index', '列表', '2', '1', '1589580432', '1589580432'), ('54', 'mall.goods/stock', '入库', '2', '1', '1589580432', '1589580432'), ('55', 'mall.goods/add', '添加', '2', '1', '1589580432', '1589580432'), ('56', 'mall.goods/edit', '编辑', '2', '1', '1589580432', '1589580432'), ('57', 'mall.goods/delete', '删除', '2', '1', '1589580432', '1589580432'), ('58', 'mall.goods/export', '导出', '2', '1', '1589580432', '1589580432'), ('59', 'mall.goods/modify', '属性修改', '2', '1', '1589580432', '1589580432'), ('60', 'system.quick', '快捷入口管理', '1', '1', '1589623188', '1589623188'), ('61', 'system.quick/index', '列表', '2', '1', '1589623188', '1589623188'), ('62', 'system.quick/add', '添加', '2', '1', '1589623188', '1589623188'), ('63', 'system.quick/edit', '编辑', '2', '1', '1589623188', '1589623188'), ('64', 'system.quick/delete', '删除', '2', '1', '1589623188', '1589623188'), ('65', 'system.quick/export', '导出', '2', '1', '1589623188', '1589623188'), ('66', 'system.quick/modify', '属性修改', '2', '1', '1589623188', '1589623188'), ('67', 'system.log', '操作日志管理', '1', '1', '1589623188', '1589623188'), ('68', 'system.log/index', '列表', '2', '1', '1589623188', '1589623188');
COMMIT;

-- ----------------------------
--  Table structure for `ea_system_quick`
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_quick`;
CREATE TABLE `ea_system_quick` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL COMMENT '快捷入口名称',
  `icon` varchar(100) DEFAULT NULL COMMENT '图标',
  `href` varchar(255) DEFAULT NULL COMMENT '快捷链接',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统快捷入口表';

-- ----------------------------
--  Records of `ea_system_quick`
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_quick` VALUES ('1', '管理员管理', 'fa fa-user', 'system.admin/index', '0', '1', '', '1589624097', '1589624792', null), ('2', '角色管理', 'fa fa-bitbucket-square', 'system.auth/index', '0', '1', '', '1589624772', '1589624781', null), ('3', '菜单管理', 'fa fa-tree', 'system.menu/index', '0', '1', null, '1589624097', '1589624792', null), ('6', '节点管理', 'fa fa-list', 'system.node/index', '0', '1', null, '1589624772', '1589624781', null), ('7', '配置管理', 'fa fa-asterisk', 'system.config/index', '0', '1', null, '1589624097', '1589624792', null), ('8', '上传管理', 'fa fa-arrow-up', 'system.uploadfile/index', '0', '1', null, '1589624772', '1589624781', null), ('10', '商品分类', 'fa fa-calendar-check-o', 'mall.cate/index', '0', '1', null, '1589624097', '1589624792', null), ('11', '商品管理', 'fa fa-list', 'mall.goods/index', '0', '1', null, '1589624772', '1589624781', null);
COMMIT;

-- ----------------------------
--  Table structure for `ea_system_uploadfile`
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_uploadfile`;
CREATE TABLE `ea_system_uploadfile` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `upload_type` varchar(20) NOT NULL DEFAULT 'local' COMMENT '存储位置',
  `original_name` varchar(255) DEFAULT NULL COMMENT '文件原名',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '物理路径',
  `image_width` varchar(30) NOT NULL DEFAULT '' COMMENT '宽度',
  `image_height` varchar(30) NOT NULL DEFAULT '' COMMENT '高度',
  `image_type` varchar(30) NOT NULL DEFAULT '' COMMENT '图片类型',
  `image_frames` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片帧数',
  `mime_type` varchar(100) NOT NULL DEFAULT '' COMMENT 'mime类型',
  `file_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `file_ext` varchar(100) DEFAULT NULL,
  `sha1` varchar(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
  `create_time` int(10) DEFAULT NULL COMMENT '创建日期',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `upload_time` int(10) DEFAULT NULL COMMENT '上传时间',
  PRIMARY KEY (`id`),
  KEY `upload_type` (`upload_type`),
  KEY `original_name` (`original_name`)
) ENGINE=InnoDB AUTO_INCREMENT=317 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='上传文件表';

-- ----------------------------
--  Records of `ea_system_uploadfile`
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_uploadfile` VALUES ('286', 'alioss', 'image/jpeg', 'https://lxn-99php.oss-cn-shenzhen.aliyuncs.com/upload/20191111/0a6de1ac058ee134301501899b84ecb1.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', null, null, null), ('287', 'alioss', 'image/jpeg', 'https://lxn-99php.oss-cn-shenzhen.aliyuncs.com/upload/20191111/46d7384f04a3bed331715e86a4095d15.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', null, null, null), ('288', 'alioss', 'image/x-icon', 'https://lxn-99php.oss-cn-shenzhen.aliyuncs.com/upload/20191111/7d32671f4c1d1b01b0b28f45205763f9.ico', '', '', '', '0', 'image/x-icon', '0', 'ico', '', null, null, null), ('289', 'alioss', 'image/jpeg', 'https://lxn-99php.oss-cn-shenzhen.aliyuncs.com/upload/20191111/28cefa547f573a951bcdbbeb1396b06f.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', null, null, null), ('290', 'alioss', 'image/jpeg', 'https://lxn-99php.oss-cn-shenzhen.aliyuncs.com/upload/20191111/2c412adf1b30c8be3a913e603c7b6e4a.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', null, null, null), ('291', 'alioss', 'timg (1).jpg', 'http://easyadmin.oss-cn-shenzhen.aliyuncs.com/upload/20191113/ff793ced447febfa9ea2d86f9f88fa8e.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', '1573612437', null, null), ('296', 'txcos', '22243.jpg', 'https://easyadmin-1251997243.cos.ap-guangzhou.myqcloud.com/upload/20191114/2381eaf81208ac188fa994b6f2579953.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', '1573712153', null, null), ('297', 'local', 'timg.jpg', 'http://admin.host/upload/20200423/5055a273cf8e3f393d699d622b74f247.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', '1587614155', null, null), ('298', 'local', 'timg.jpg', 'http://admin.host/upload/20200423/243f4e59f1b929951ef79c5f8be7468a.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', '1587614269', null, null), ('299', 'local', 'head.jpg', 'http://admin.host/upload/20200512/a5ce9883379727324f5686ef61205ce2.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', '1589255649', null, null), ('300', 'local', '896e5b87c9ca70e4.jpg', 'http://admin.host/upload/20200514/577c65f101639f53dbbc9e7aa346f81c.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', '1589427798', null, null), ('301', 'local', '896e5b87c9ca70e4.jpg', 'http://admin.host/upload/20200514/98fc09b0c4ad4d793a6f04bef79a0edc.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', '1589427840', null, null), ('302', 'local', '18811e7611c8f292.jpg', 'http://admin.host/upload/20200514/e1c6c9ef6a4b98b8f7d95a1a0191a2df.jpg', '', '', '', '0', 'image/jpeg', '0', 'jpg', '', '1589438645', null, null), ('316', 'local', '图层 10.png', 'http://www.p.com/upload/20200916/6a3039f2ca68326ff58a08d97b3f85d9.png', '', '', '', '0', 'image/png', '0', 'png', '', '1600245941', null, null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
